<%@ page language="java" import="java.util.*,java.sql.*" pageEncoding="utf-8" errorPage="/error.html"%>
<%@page import="com.bean.LoginBean"%>


<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    
    <title>办公室自动化OA系统</title>
    <style type="text/css"> 
<!-- 
body {
	margin-left: 0px;
	margin-top: 0px;
	margin-right: 0px;
	margin-bottom: 0px;
	color: #333333;
	background-color: #2286C2;
}
a:link { 
font-size: 14px; 
color: #000000; 
text-decoration: none; 
} 
a:visited { 
font-size: 14px; 
color: #000000; 
text-decoration: none; 
} 
a:hover { 
font-size: 14px; 
color: #999999; 
text-decoration: underline; 
} 
--> 
</style>
	<meta http-equiv="pragma" content="no-cache">
	<meta http-equiv="cache-control" content="no-cache">
	<meta http-equiv="expires" content="0">    
	<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
	<meta http-equiv="description" content="This is my page">
	<!--
	<link rel="stylesheet" type="text/css" href="styles.css">
	-->
<script language=javascript>
function show_total()
{for (var j=1;j<19;j++){
for(var i=1;i<20;i++)
{
var a = document.getElementById(j+"@"+i);
if(a==null)
{
continue;
}
if(a.style.display=="")
{
a.style.display="none";
}else{
a.style.display="";
}
}}
}
function show(no)
{
for(var i=1;i<20;i++)
{
var a = document.getElementById(no+"@"+i);
if(a==null)
{
continue;
}
if(a.style.display=="")
{
a.style.display="none";
}else{
a.style.display="";
}
}

}
function change(no)
{
var c = document.getElementById("c");
c.innerHTML=no;
}
</script>

  </head>
  
  <body onload="show_total()">
<%
LoginBean LoginBean= (LoginBean)session.getAttribute("Loginbean");
String username111=LoginBean.getUsername();
 %>
 <%  
 //连接MySQL数据库   
    Class.forName("com.mysql.jdbc.Driver").newInstance();  
    String url="jdbc:mysql://localhost:3306/graduatedesign";  
    String user="root";  
    String password="root";  
    Connection conn = DriverManager.getConnection(url, user, password);  
    Statement st = conn.createStatement();  
 %>  
<table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td height="74" colspan="2" background="/OA/admin/images/index1_03.gif">
      <table width="100%" border="0" cellspacing="0" cellpadding="0">
        <tr>
          <td width="2%" rowspan="2">&nbsp;</td>
          <td width="31%" rowspan="2"><span class="STYLE1">办公室自动化OA系统</span></td>
          <td width="6%" rowspan="2">&nbsp;</td>
          <td width="61%" height="38" align="right">&nbsp;</td>
        </tr>
        <tr>
          <td align="right">
            <table width="100%" border="0" cellspacing="0" cellpadding="0">
              <tr>
                <td align="right" class="font2"><a href="changepass.jsp" target="main">修改密码</a>&nbsp;&nbsp;登陆用户：
                <%if(LoginBean!=null){ %>
                <%=LoginBean.getUsername()%>&nbsp;&nbsp;
                <%} %>
                <a href="/OA/index.html" class="font2"><strong>退出</strong></a>&nbsp;</td>
              </tr>
            </table>          </td>
        </tr>
      </table>
    </td>
  </tr>
  <tr>
    <td colspan="2">
      <table width="100%" border="0" cellspacing="10" cellpadding="0">
        <tr>
          <td width="10%" valign="top">
            <table width="100%" border="0" cellspacing="0" cellpadding="0">
              <tr>
                <td width="8" height="8"><img src="/OA/admin/images/index1_23.gif" width="8" height="29" /></td>
                <td width="99%" background="/OA/admin/images/index1_24.gif"><font style="color:transparent" style="cursor:hand" onClick="show_total()">展开所有</font></td>
                <td width="8" height="8"><img src="/OA/admin/images/index1_26.gif" width="8" height="29" /></td>
              </tr>
              <tr>
                <td background="/OA/admin/images/index1_45.gif"></td>
                <td bgcolor="#FFFFFF" style="padding:0 2px 0 2px; vertical-align:top;height:500px;">
                 
                  <table width="200" border="0" cellpadding="0" cellspacing="5">
                  

                    <tr  onClick="show('6')" style="cursor: hand" >
                      <td width="12%" align="center"><img src="/OA/admin/images/index1_54.gif" width="15" height="11" /></td>
                      <td width="88%">我的信息</td>
                    </tr>
                    
                    <tr id="6@1">
                      <td align="center"></td>
                      <td>
                        <table width="100%" border="0" cellspacing="5" cellpadding="0">
                      
                          <tr onClick="change('我的信息 > 信息修改')" style="cursor: hand" >
                            <td width="18%" align="center"><img src="/OA/admin/images/index1_68.gif" width="11" height="14" /></td>
                            <td width="82%"><a href="userinfo.jsp" target="main">信息修改</a></td>
                          </tr>
                          <tr onClick="change('我的信息 > 文档管理')" style="cursor: hand" >
                            <td width="18%" align="center"><img src="/OA/admin/images/index1_68.gif" width="11" height="14" /></td>
                            <td width="82%"><a href="upload.jsp" target="main">文档管理</a></td>
                          </tr>

                        </table>
                      </td>
                    </tr>
                    
                                                 <tr  onClick="show('18')" style="cursor: hand" >
                      <td width="12%" align="center"><img src="/OA/admin/images/index1_54.gif" width="15" height="11" /></td>
                      <td width="88%">考勤管理</td>
                    </tr>
                    <tr id="18@1">
                      <td align="center"></td>
                      <td>
                        <table width="100%" border="0" cellspacing="5" cellpadding="0">
                          <tr onClick="change('考勤管理 > 上下班打卡')" style="cursor: hand" >
                            <td width="18%" align="center"><img src="/OA/admin/images/index1_68.gif" width="11" height="14" /></td>
                            <td width="82%"><a href="daka.jsp" target="main">上下班打卡</a></td>
                          </tr>
                   <%ResultSet rs9 = st.executeQuery("SELECT kqtj FROM role a,user b where b.utype='"+LoginBean.getUtype()+"' and a.role=b.utype");
                   if(rs9.next()){
                   if
                   (
                   rs9.getString("kqtj").toString().equals("1")
                   ) {%>
                          <tr onClick="change('考勤管理 > 考勤统计')" style="cursor: hand" >
                            <td width="18%" align="center"><img src="/OA/admin/images/index1_68.gif" width="11" height="14" /></td>
                            <td width="82%"><a href="kaoqtj.jsp" target="main">考勤统计</a></td>
                          </tr>
                   <%} }%>
                        </table>
                      </td>
                    </tr>
                    
                    <%ResultSet rs1 = st.executeQuery("SELECT Notice,Noticeadd FROM role a,user b where b.utype='"+LoginBean.getUtype()+"' and a.role=b.utype");
                    if(rs1.next()){
                    String notice1=rs1.getString("Notice");
                    String noticeadd=rs1.getString("Noticeadd");
}
                    if
                    (
                    rs1.getString("Notice").toString().equals("1")
                    ) {%>
                    
                    <tr  onClick="show('8')" style="cursor: hand" >
                      <td width="12%" align="center"><img src="/OA/admin/images/index1_54.gif" width="15" height="11" /></td>
                      <td width="88%">公告与会议通知</td>
                    </tr>
                    
                    <tr id="8@1">
                      <td align="center"></td>
                      <td>
                        <table width="100%" border="0" cellspacing="5" cellpadding="0">
                          <tr onClick="change('公告与会议通知 > 公告与会议通知')" style="cursor: hand" >
                            <td width="18%" align="center"><img src="/OA/admin/images/index1_68.gif" width="11" height="14" /></td>
                            <td width="82%"><a href="notice.jsp" target="main">查看公告会议通知</a></td>
                          </tr>
                   <%if (rs1.getString("Noticeadd").equals("1")) {%>
                          <tr onClick="change('公告与会议通知 > 添加公告与会议通知')" style="cursor: hand" >
                            <td width="18%" align="center"><img src="/OA/admin/images/index1_68.gif" width="11" height="14" /></td>
                            <td width="82%"><a href="noticeadd.jsp" target="main">添加公告会议通知</a></td>
                          </tr>
                          <tr onClick="change('公告与会议通知 > 公告与会议通知管理')" style="cursor: hand" >
                            <td width="18%" align="center"><img src="/OA/admin/images/index1_68.gif" width="11" height="14" /></td>
                            <td width="82%"><a href="noticeall.jsp" target="main">公告会议通知管理</a></td>
                          </tr>
                   <%} %>
                        </table>
                      </td>
                    </tr>
                   <%} %>
                   
                   
                   
                 
                   <%ResultSet rs2 = st.executeQuery("SELECT userrcd FROM role a,user b where b.utype='"+LoginBean.getUtype()+"' and a.role=b.utype");
                    if(rs2.next()){
                    String userrcd=rs2.getString("userrcd");
}
                    if
                    (
                    rs2.getString("userrcd").toString().equals("1")
                    ) {%>
                    
                    <tr  onClick="show('10')" style="cursor: hand" >
                      <td width="12%" align="center"><img src="/OA/admin/images/index1_54.gif" width="15" height="11" /></td>
                      <td width="88%">人员履历</td>
                    </tr>
                    
                    <tr id="10@1">
                      <td align="center"></td>
                      <td>
                        <table width="100%" border="0" cellspacing="5" cellpadding="0">
                          <tr onClick="change('人员履历 > 履历添加')" style="cursor: hand" >
                            <td width="18%" align="center"><img src="/OA/admin/images/index1_68.gif" width="11" height="14" /></td>
                            <td width="82%"><a href="userrcdadd.jsp" target="main">履历添加</a></td>
                          </tr>
                          <tr onClick="change('人员履历 > 履历管理')" style="cursor: hand" >
                            <td width="18%" align="center"><img src="/OA/admin/images/index1_68.gif" width="11" height="14" /></td>
                            <td width="82%"><a href="userrcdmanage.jsp" target="main">履历管理</a></td>
                          </tr>
                        </table>
                      </td>
                    </tr>
                   <%} %>
                   
                   
                   
                      <tr  onClick="show('11')" style="cursor: hand" >
                      <td width="12%" align="center"><img src="/OA/admin/images/index1_54.gif" width="15" height="11" /></td>
                      <td width="88%">部门管理</td>
                    </tr>
                    <tr id="11@1">
                      <td align="center"></td>
                      <td>
                        <table width="100%" border="0" cellspacing="5" cellpadding="0">
                          <tr onClick="change('部门管理 > 部门查询')" style="cursor: hand" >
                            <td width="18%" align="center"><img src="/OA/admin/images/index1_68.gif" width="11" height="14" /></td>
                            <td width="82%"><a href="deptall.jsp" target="main">部门查询</a></td>
                          </tr>
                   <%ResultSet rs3 = st.executeQuery("SELECT dept FROM role a,user b where b.utype='"+LoginBean.getUtype()+"' and a.role=b.utype");
                   if(rs3.next()){
                   if
                   (
                   rs3.getString("dept").toString().equals("1")
                   ) {%>
                          <tr onClick="change('部门管理 > 部门管理')" style="cursor: hand" >
                            <td width="18%" align="center"><img src="/OA/admin/images/index1_68.gif" width="11" height="14" /></td>
                            <td width="82%"><a href="dept.jsp" target="main">部门管理</a></td>
                          </tr>
                   <%} }%>
                        </table>
                      </td>
                    </tr>
                    
                   <tr  onClick="show('12')" style="cursor: hand" >
                      <td width="12%" align="center"><img src="/OA/admin/images/index1_54.gif" width="15" height="11" /></td>
                      <td width="88%">用户管理</td>
                    </tr>
                    <tr id="12@1">
                      <td align="center"></td>
                      <td>
                        <table width="100%" border="0" cellspacing="5" cellpadding="0">
                          <tr onClick="change('用户管理 > 用户查询')" style="cursor: hand" >
                            <td width="18%" align="center"><img src="/OA/admin/images/index1_68.gif" width="11" height="14" /></td>
                            <td width="82%"><a href="userall.jsp" target="main">用户查询</a></td>
                          </tr>
                   <%ResultSet rs4 = st.executeQuery("SELECT user FROM role a,user b where b.utype='"+LoginBean.getUtype()+"' and a.role=b.utype");
                   if(rs4.next()){
                   if
                   (
                   rs4.getString("user").toString().equals("1")
                   ) {%>
                          <tr onClick="change('用户管理 > 用户管理')" style="cursor: hand" >
                            <td width="18%" align="center"><img src="/OA/admin/images/index1_68.gif" width="11" height="14" /></td>
                            <td width="82%"><a href="user.jsp" target="main">用户管理</a></td>
                          </tr>
                   <%} }%>
                        </table>
                      </td>
                    </tr>
                     <%ResultSet rs5 = st.executeQuery("SELECT qxgl FROM role a,user b where b.utype='"+LoginBean.getUtype()+"' and a.role=b.utype");
                    if(rs5.next()){
                    String userrcd=rs5.getString("qxgl");
}
                    if
                    (
                    rs5.getString("qxgl").toString().equals("1")
                    ) {%>
                    
                    <tr  onClick="show('13')" style="cursor: hand" >
                      <td width="12%" align="center"><img src="/OA/admin/images/index1_54.gif" width="15" height="11" /></td>
                      <td width="88%">角色与权限管理</td>
                    </tr>
                    
                    <tr id="13@1">
                      <td align="center"></td>
                      <td>
                        <table width="100%" border="0" cellspacing="5" cellpadding="0">
                          <tr onClick="change('角色与权限管理 > 角色与权限管理')" style="cursor: hand" >
                            <td width="18%" align="center"><img src="/OA/admin/images/index1_68.gif" width="11" height="14" /></td>
                            <td width="82%"><a href="role.jsp" target="main">角色与权限管理</a></td>
                          </tr>
                        </table>
                      </td>
                    </tr>
                   <%} %>
                   
                   
                    <tr  onClick="show('14')" style="cursor: hand" >
                      <td width="12%" align="center"><img src="/OA/admin/images/index1_54.gif" width="15" height="11" /></td>
                      <td width="88%">人事管理</td>
                    </tr>
                    <tr id="14@1">
                      <td align="center"></td>
                      <td>
                        <table width="100%" border="0" cellspacing="5" cellpadding="0">
                          <tr onClick="change('人事管理 > 转正申请')" style="cursor: hand" >
                            <td width="18%" align="center"><img src="/OA/admin/images/index1_68.gif" width="11" height="14" /></td>
                            <td width="82%"><a href="zzsq.jsp" target="main">转正申请</a></td>
                          </tr>
                          <tr onClick="change('人事管理 > 离职申请')" style="cursor: hand" >
                            <td width="18%" align="center"><img src="/OA/admin/images/index1_68.gif" width="11" height="14" /></td>
                            <td width="82%"><a href="lzsq.jsp" target="main">离职申请</a></td>
                          </tr>
                   <%ResultSet rs6 = st.executeQuery("SELECT zzsp FROM role a,user b where b.utype='"+LoginBean.getUtype()+"' and a.role=b.utype");
                   if(rs6.next()){
                   if
                   (
                   rs6.getString("zzsp").toString().equals("1")
                   ) {%>
                          <tr onClick="change('人事管理 > 转正审批')" style="cursor: hand" >
                            <td width="18%" align="center"><img src="/OA/admin/images/index1_68.gif" width="11" height="14" /></td>
                            <td width="82%"><a href="zzsp.jsp" target="main">转正审批</a></td>
                          </tr>
                   <%} }%>
                   <%ResultSet rs7 = st.executeQuery("SELECT lzsp FROM role a,user b where b.utype='"+LoginBean.getUtype()+"' and a.role=b.utype");
                   if(rs7.next()){
                   if
                   (
                   rs7.getString("lzsp").toString().equals("1")
                   ) {%>
                          <tr onClick="change('人事管理 > 离职审批')" style="cursor: hand" >
                            <td width="18%" align="center"><img src="/OA/admin/images/index1_68.gif" width="11" height="14" /></td>
                            <td width="82%"><a href="lzsp.jsp" target="main">离职审批</a></td>
                          </tr>
                   <%} }%>
                        </table>
                      </td>
                    </tr>
                    
                    
                     <tr  onClick="show('15')" style="cursor: hand" >
                      <td width="12%" align="center"><img src="/OA/admin/images/index1_54.gif" width="15" height="11" /></td>
                      <td width="88%">请假管理</td>
                    </tr>
                    <tr id="15@1">
                      <td align="center"></td>
                      <td>
                        <table width="100%" border="0" cellspacing="5" cellpadding="0">
                          <tr onClick="change('请假管理 > 请假申请')" style="cursor: hand" >
                            <td width="18%" align="center"><img src="/OA/admin/images/index1_68.gif" width="11" height="14" /></td>
                            <td width="82%"><a href="qjinfoadd.jsp" target="main">请假申请</a></td>
                          </tr>
                          <tr onClick="change('请假管理 > 请假记录')" style="cursor: hand" >
                            <td width="18%" align="center"><img src="/OA/admin/images/index1_68.gif" width="11" height="14" /></td>
                            <td width="82%"><a href="qjinfo.jsp" target="main">请假记录</a></td>
                          </tr>
                   <%ResultSet rs8 = st.executeQuery("SELECT qjsp FROM role a,user b where b.utype='"+LoginBean.getUtype()+"' and a.role=b.utype");
                   if(rs8.next()){
                   if
                   (
                   rs8.getString("qjsp").toString().equals("1")
                   ) {%>
                          <tr onClick="change('请假管理 > 请假审批')" style="cursor: hand" >
                            <td width="18%" align="center"><img src="/OA/admin/images/index1_68.gif" width="11" height="14" /></td>
                            <td width="82%"><a href="qjsp.jsp" target="main">请假审批</a></td>
                          </tr>
                   <%} }%>
                        </table>
                      </td>
                    </tr>
                    
                    <tr  onClick="show('16')" style="cursor: hand" >
                      <td width="12%" align="center"><img src="/OA/admin/images/index1_54.gif" width="15" height="11" /></td>
                      <td width="88%">我的便签</td>
                    </tr>
                    <tr id="16@1">
                      <td align="center"></td>
                      <td>
                        <table width="100%" border="0" cellspacing="5" cellpadding="0">
                          <tr onClick="change('我的便签 > 管理')" style="cursor: hand" >
                            <td width="18%" align="center"><img src="/OA/admin/images/index1_68.gif" width="11" height="14" /></td>
                            <td width="82%"><a href="notemanage.jsp" target="main">管理</a></td>
                          </tr>
                          <tr onClick="change('我的便签 > 我的便签')" style="cursor: hand" >
                            <td width="18%" align="center"><img src="/OA/admin/images/index1_68.gif" width="11" height="14" /></td>
                            <td width="82%"><a href="note.jsp" target="main">我的便签</a></td>
                          </tr>
                          <tr onClick="change('我的便签 > 添加')" style="cursor: hand" >
                            <td width="18%" align="center"><img src="/OA/admin/images/index1_68.gif" width="11" height="14" /></td>
                            <td width="82%"><a href="noteadd.jsp" target="main">添加</a></td>
                          </tr>
                        </table>
                      </td>
                    </tr>
                    
                    <tr  onClick="show('17')" style="cursor: hand" >
                      <td width="12%" align="center"><img src="/OA/admin/images/index1_54.gif" width="15" height="11" /></td>
                      <td width="88%">我的联系人</td>
                    </tr>
                    <tr id="17@1">
                      <td align="center"></td>
                      <td>
                        <table width="100%" border="0" cellspacing="5" cellpadding="0">
                          <tr onClick="change('我的联系人 > 添加')" style="cursor: hand" >
                            <td width="18%" align="center"><img src="/OA/admin/images/index1_68.gif" width="11" height="14" /></td>
                            <td width="82%"><a href="linkfind.jsp" target="main">添加联系人</a></td>
                          </tr>
                          <tr onClick="change('我的联系人 > 管理')" style="cursor: hand" >
                            <td width="18%" align="center"><img src="/OA/admin/images/index1_68.gif" width="11" height="14" /></td>
                            <td width="82%"><a href="linkmanage.jsp" target="main">管理联系人</a></td>
                          </tr>
                        </table>
                      </td>
                    </tr>
                    
            
                    
                   
                  </table>
                </td>
                <td background="/OA/admin/images/index1_47.gif"></td>
              </tr>
              <tr>
                <td width="8" height="8"><img src="/OA/admin/images/index1_91.gif" width="8" height="8" /></td>
                <td background="/OA/admin/images/index1_92.gif"></td>
                <td width="8" height="8"><img src="/OA/admin/images/index1_93.gif" width="8" height="8" /></td>
              </tr>
            </table>
          </td>
          <td width="70%" valign="top">
            <table width="100%" border="0" cellspacing="0" cellpadding="0">
             <tr>
                <td width="8" height="8"><img src="/OA/admin/images/index1_23.gif" width="8" height="29" /></td>
                <td width="99%" background="/OA/admin/images/index1_24.gif"></td>
                <td width="8" height="8"><img src="/OA/admin/images/index1_26.gif" width="8" height="29" /></td>
              </tr>
              <tr height="200">
                <td height="500" background="/OA/admin/images/index1_45.gif"></td>
                <td width="99%" bgcolor="#FFFFFF" style="height:490px; vertical-align:top;">
                  <table width="100%" border="0" cellspacing="10" cellpadding="0">
                    <tr>
                      <td>
                        <table width="100%" border="0" cellpadding="0" cellspacing="1" bgcolor="#FFFFFF">
                          <tr>
                            <td>
                              <table width="100%" border="0" cellpadding="0" cellspacing="5" bgcolor="#FFFFFF">
                                <tr>
                                  <td height="20">&nbsp;
                                  
                                  &nbsp;&nbsp;&nbsp;您当前的位置：
                                  <div style="display: inline;" id="c">我的信息</div>
                                  
                                  </td>
                                </tr>
                              </table>                            </td>
                          </tr>
                        </table>                      </td>
                    </tr>
                    <tr>
                      <td>
                       <iframe width="100%"  scrolling="yes" frameborder="0" height="340" src="userinfo.jsp"  style=background:transparent allowtransparency name="main"></iframe>  
                     </td>
                    </tr>
                </table>                </td>
                <td background="/OA/admin/images/index1_47.gif"></td>
              </tr>
              <tr>
                <td width="8" height="8"><img src="/OA/admin/images/index1_91.gif" width="8" height="8" /></td>
                <td background="/OA/admin/images/index1_92.gif"></td>
                <td width="8" height="8"><img src="/OA/admin/images/index1_93.gif" width="8" height="8" /></td>
              </tr>
            </table>
          </td>
        </tr>
      </table>
    </td>
  </tr>
</table>
  </body>
</html>
